﻿<?xml version="1.0" encoding="utf-8" ?>
<AdoNetDataAccess connection="$ArticleDBConnection$" formatter="bizobj of Article">
	<Sql>
SELECT        a.id, tc.treeName
FROM            Articles AS a INNER JOIN
                         ObjectTreeCounts as tc ON a.id = tc.objectId
WHERE        (a.uniqueTitle = @uniqueTitle) AND (a.companyId = @companyId) AND (tc.treeName = @treeName)
	</Sql>
	<Param name="uniqueTitle" type="UnicodeVarChar" />
	<Param name="treeName" type="String" />
	<Param name="companyId" type="UniqueIdentifier" />
</AdoNetDataAccess>
